CREATE TABLE [dbo].[SeasonalFullAddress]
(
[SeasonalFullAddressKey] [uniqueidentifier] NOT NULL,
[FullAddressKey] [uniqueidentifier] NOT NULL,
[ReplacesFullAddressKey] [uniqueidentifier] NOT NULL,
[BeginDate] [datetime] NOT NULL,
[EndDate] [datetime] NULL,
[IsSeasonalAnnually] [bit] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[SeasonalFullAddress] ADD CONSTRAINT [PK_SeasonalFullAddress] PRIMARY KEY CLUSTERED ([SeasonalFullAddressKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SeasonalFullAddress_ReplacesFullAddressKey] ON [dbo].[SeasonalFullAddress] ([ReplacesFullAddressKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SeasonalFullAddress] ADD CONSTRAINT [FK_SeasonalFullAddress_FullAddress] FOREIGN KEY ([FullAddressKey]) REFERENCES [dbo].[FullAddress] ([FullAddressKey])
GO
ALTER TABLE [dbo].[SeasonalFullAddress] ADD CONSTRAINT [FK_SeasonalFullAddress_FullAddress_Replaces] FOREIGN KEY ([ReplacesFullAddressKey]) REFERENCES [dbo].[FullAddress] ([FullAddressKey])
GO